Job Overview
We are committed to establishing a solid foundation for data-driven health care interventions. As an independent state agency, our credible work is recognized by policymakers, health care leaders, and researchers in developing policies that enhance the quality and equity of care while ensuring affordability for families.
By joining our team, you will play a pivotal role in transforming health care data into actionable insights, contributing to the development of engaging content and campaigns that support evidence-based decision-making.
Key Responsibilities
As an ETL Developer, you will be integral to our ETL Development team. Your primary responsibilities include:
- Designing and implementing ETL processes for extracting and transforming data from diverse sources, including databases and flat files.
- Gaining practical experience with leading ETL tools such as IBM DataStage and Qlik Talend.
- Creating and developing essential database tables utilizing Snowflake, PostgreSQL, and SQL Server technologies.
- Collaborating with team members to comprehend source system structures and data retrieval methods.
- Supporting the creation of data transformation logic using ETL tools or scripting languages like SQL, Bash, and Python.
- Cleaning, validating, and transforming data to align with target schemas and quality standards.
- Working collaboratively to execute data quality improvement initiatives.
- Engaging in troubleshooting activities to ensure data integrity and enhance process efficiency.
Required Skills
To excel in this role, candidates should possess the following skills:
- Proficiency in ETL Development within a health data organization.
- Familiarity with ETL tools such as IBM DataStage or Qlik Talend.
- Experience with Linux and Windows systems.
- Knowledge of database technologies including Snowflake, PostgreSQL, and SQL Server.
- Proficiency in programming languages such as SQL and Bash.
- Strong ability to work independently in fully remote, hybrid, or in-person settings.
- Understanding of SDLC models and knowledge of HIPAA policies concerning PII and PHI data.
- Proven track record of successful collaboration within a diverse IT team.
- Excellent communication skills, both verbal and written, along with strong documentation capabilities.
- A detail-oriented and organized approach to work, especially while managing deadlines.
- Experience with Microsoft DevOps/Azure is preferred.
Qualifications
Candidates must meet the following qualifications:
- A Bachelor's degree in computer science, information technology, or a related field.
- Relevant experience in ETL Development within a health data organization.
Career Growth Opportunities
We value the expertise you bring and are dedicated to fostering your professional growth. Joining our organization will provide you with the opportunity to make a significant impact in health care and contribute to shaping the future of health policy.
Company Culture And Values
We promote a flexible and collaborative work environment with a hybrid model that includes both in-person and remote work options. You will have the chance to engage with colleagues in our vibrant Boston office while enjoying the benefits of remote work flexibility.
Compensation And Benefits
We offer a competitive salary range of \(105,000 - \)115,000 for this position, along with a comprehensive suite of employee benefits designed to support you and your future endeavors.
Apply Now!
If you believe you have the qualifications and drive to thrive in this role, we encourage you to apply. We are committed to equal opportunity and affirmative action, welcoming applications from individuals of diverse backgrounds including females, minorities, veterans, and persons with disabilities.
Employment Type: Full-Time